/*
 Navicat Premium Data Transfer

 Source Server         : 本地连接
 Source Server Type    : MySQL
 Source Server Version : 80033 (8.0.33)
 Source Host           : localhost:3306
 Source Schema         : tech-forge-dev

 Target Server Type    : MySQL
 Target Server Version : 80033 (8.0.33)
 File Encoding         : 65001

 Date: 25/05/2025 15:33:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for pserv_basic_comm_biz_no
-- ----------------------------
DROP TABLE IF EXISTS `pserv_basic_comm_biz_no`;
CREATE TABLE `pserv_basic_comm_biz_no` (
  `id` bigint NOT NULL COMMENT '主键',
  `biz_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务类型',
  `biz_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务类型名称',
  `step` int DEFAULT NULL COMMENT '每次获取多少个序号',
  `prefix` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '前缀',
  `batch` int DEFAULT NULL COMMENT '批次',
  `batch_len` int DEFAULT NULL COMMENT '批次长度',
  `current_num` int DEFAULT NULL COMMENT '当前序号',
  `num_len` int DEFAULT NULL COMMENT '序号长度',
  `fill_char` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '批次或序号长度不足时填充符号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-BASIC-通用业务编号管理';

-- ----------------------------
-- Records of pserv_basic_comm_biz_no
-- ----------------------------
BEGIN;
INSERT INTO `pserv_basic_comm_biz_no` (`id`, `biz_type`, `biz_type_name`, `step`, `prefix`, `batch`, `batch_len`, `current_num`, `num_len`, `fill_char`) VALUES (1, 'plate_user_no', NULL, 1, 'PUN', 1, 4, 16, 6, '0');
INSERT INTO `pserv_basic_comm_biz_no` (`id`, `biz_type`, `biz_type_name`, `step`, `prefix`, `batch`, `batch_len`, `current_num`, `num_len`, `fill_char`) VALUES (2, 'plate_tenant_no', NULL, 1, 'PTN', 1, 4, 5, 6, '0');
INSERT INTO `pserv_basic_comm_biz_no` (`id`, `biz_type`, `biz_type_name`, `step`, `prefix`, `batch`, `batch_len`, `current_num`, `num_len`, `fill_char`) VALUES (3, 'tenant_department_no', NULL, 1, 'TDN', 1, 4, 16, 6, '0');
INSERT INTO `pserv_basic_comm_biz_no` (`id`, `biz_type`, `biz_type_name`, `step`, `prefix`, `batch`, `batch_len`, `current_num`, `num_len`, `fill_char`) VALUES (4, 'department_post_no', NULL, 1, 'DPN', 1, 4, 15, 6, '0');
INSERT INTO `pserv_basic_comm_biz_no` (`id`, `biz_type`, `biz_type_name`, `step`, `prefix`, `batch`, `batch_len`, `current_num`, `num_len`, `fill_char`) VALUES (5, 'plate_role_no', NULL, 1, 'PRN', 1, 4, 4, 6, '0');
COMMIT;

-- ----------------------------
-- Table structure for pserv_basic_comm_config
-- ----------------------------
DROP TABLE IF EXISTS `pserv_basic_comm_config`;
CREATE TABLE `pserv_basic_comm_config` (
  `id` bigint NOT NULL COMMENT '字典id',
  `config_type_id` bigint DEFAULT NULL COMMENT '配置类型id',
  `config_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配置名',
  `config_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '配置键',
  `config_value` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '配置值',
  `enable_flag` tinyint(1) DEFAULT NULL COMMENT '是否生效',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` bigint NOT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-BASIC-通用系统配置类型表';

-- ----------------------------
-- Records of pserv_basic_comm_config
-- ----------------------------
BEGIN;
INSERT INTO `pserv_basic_comm_config` (`id`, `config_type_id`, `config_name`, `config_key`, `config_value`, `enable_flag`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1921922644907667456, 1921563792160911360, '微信', 'wx', 'channel_wx', 1, '2025-05-12 21:37:21', 1, NULL, NULL, NULL);
INSERT INTO `pserv_basic_comm_config` (`id`, `config_type_id`, `config_name`, `config_key`, `config_value`, `enable_flag`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1924011340679151616, 1921563792160911360, '支付宝', 'alipay', 'channel_alipay', 1, '2025-05-18 15:57:05', 1, '2025-05-18 15:57:17', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_basic_comm_config_type
-- ----------------------------
DROP TABLE IF EXISTS `pserv_basic_comm_config_type`;
CREATE TABLE `pserv_basic_comm_config_type` (
  `id` bigint NOT NULL COMMENT '主键',
  `config_type_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配置类型',
  `config_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配置类型名称',
  `enable_flag` tinyint(1) DEFAULT NULL COMMENT '是否可用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-BASIC-通用系统配置表';

-- ----------------------------
-- Records of pserv_basic_comm_config_type
-- ----------------------------
BEGIN;
INSERT INTO `pserv_basic_comm_config_type` (`id`, `config_type_key`, `config_type_name`, `enable_flag`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES (1921562207510917120, '1', '112', 1, '2025-05-11 21:45:06', 1, '2025-05-11 21:49:44', 1);
INSERT INTO `pserv_basic_comm_config_type` (`id`, `config_type_key`, `config_type_name`, `enable_flag`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES (1921563792160911360, 'channel', '渠道', 1, '2025-05-11 21:51:24', 1, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_basic_comm_dict
-- ----------------------------
DROP TABLE IF EXISTS `pserv_basic_comm_dict`;
CREATE TABLE `pserv_basic_comm_dict` (
  `id` bigint NOT NULL COMMENT '字典id',
  `type_id` bigint DEFAULT NULL COMMENT '字典类型',
  `dict_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典键',
  `dict_value` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典值',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-BASIC-通用字典表';

-- ----------------------------
-- Records of pserv_basic_comm_dict
-- ----------------------------
BEGIN;
INSERT INTO `pserv_basic_comm_dict` (`id`, `type_id`, `dict_key`, `dict_value`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 1, 'male', '男', '2025-05-10 20:58:11', 9999, NULL, NULL, NULL);
INSERT INTO `pserv_basic_comm_dict` (`id`, `type_id`, `dict_key`, `dict_value`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (2, 1, 'female', '女', '2025-05-10 20:58:11', 9999, NULL, NULL, NULL);
INSERT INTO `pserv_basic_comm_dict` (`id`, `type_id`, `dict_key`, `dict_value`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (3, 1, 'secrecy', '保密', '2025-05-10 20:58:11', 9999, '2025-05-10 12:59:05', NULL, NULL);
INSERT INTO `pserv_basic_comm_dict` (`id`, `type_id`, `dict_key`, `dict_value`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1921394320443756544, 1921394257696968704, 'true', '可用', '2025-05-11 10:37:58', 1, NULL, NULL, NULL);
INSERT INTO `pserv_basic_comm_dict` (`id`, `type_id`, `dict_key`, `dict_value`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1921394368120410112, 1921394257696968704, 'false', '不可用', '2025-05-11 10:38:10', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_basic_comm_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `pserv_basic_comm_dict_type`;
CREATE TABLE `pserv_basic_comm_dict_type` (
  `id` bigint NOT NULL COMMENT '主键',
  `dict_type_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典类型',
  `dict_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字段类型名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-BASIC-通用字典类型表';

-- ----------------------------
-- Records of pserv_basic_comm_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `pserv_basic_comm_dict_type` (`id`, `dict_type_key`, `dict_type_name`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES (1, 'gender', '性别', '2025-05-10 20:57:10', 9999, NULL, NULL);
INSERT INTO `pserv_basic_comm_dict_type` (`id`, `dict_type_key`, `dict_type_name`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES (1921394257696968704, 'activeFlag', '是否可用', '2025-05-11 10:37:43', 1, '2025-05-11 13:35:31', 1);
COMMIT;

-- ----------------------------
-- Table structure for pserv_ebus_event
-- ----------------------------
DROP TABLE IF EXISTS `pserv_ebus_event`;
CREATE TABLE `pserv_ebus_event` (
  `id` bigint NOT NULL COMMENT '主键',
  `topic_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '主题编号',
  `event_key` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消息唯一key，幂等',
  `provider_ip` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '事件提供系统IP',
  `provider_sys_name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '事件提供系统名称',
  `provider_time` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '事件生产时间',
  `event_msg` text COLLATE utf8mb4_bin COMMENT '事件消息',
  `status` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '00-初始化 01-已发布 02-发布失败',
  `retry_num` int DEFAULT NULL COMMENT '已重试次数',
  `notes` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='平台服务-EBUS-事件记录';

-- ----------------------------
-- Records of pserv_ebus_event
-- ----------------------------
BEGIN;
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925541527531053056, 'spring_event_queue_test', '20250522001', '127.0.0.1', 'SYS', '2025-05-22 21:17:29', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-22 21:17:30', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925542852394246144, 'spring_event_queue_test', '20250522002', '127.0.0.1', 'SYS', '2025-05-22 21:22:45', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-22 21:22:46', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925543326120005632, 'spring_event_broadcast_test', '20250522003', '127.0.0.1', 'SYS', '2025-05-22 21:24:38', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-22 21:24:39', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926122323623047168, 'active_mq_queue_test', '20250524001', '127.0.0.1', 'SYS', '2025-05-24 11:45:22', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-24 11:45:22', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926199971854446592, 'active_mq_queue_test', '20250524002', '127.0.0.1', 'SYS', '2025-05-24 16:53:55', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-24 16:53:55', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926200149785210880, 'active_mq_broadcast_test', '20250524003', '127.0.0.1', 'SYS', '2025-05-24 16:54:37', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-24 16:54:37', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926205176683356160, 'active_mq_broadcast_test', '20250524004', '127.0.0.1', 'SYS', '2025-05-24 17:14:35', '{\"value\":\"123\"}', '01', 3, NULL, '2025-05-24 17:14:36', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926205675763589120, 'active_mq_queue_test', '20250524005', '127.0.0.1', 'SYS', '2025-05-24 17:16:34', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:16:35', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926206134788218880, 'active_mq_queue_test', '20250524006', '127.0.0.1', 'SYS', '2025-05-24 17:18:24', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:18:24', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926206284814278656, 'active_mq_broadcast_test', '20250524007', '127.0.0.1', 'SYS', '2025-05-24 17:19:00', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:19:00', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926206782108090368, 'active_mq_broadcast_test', '20250524008', '127.0.0.1', 'SYS', '2025-05-24 17:20:58', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:20:59', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926209609924616192, 'active_mq_broadcast_test', '20250524009', '127.0.0.1', 'SYS', '2025-05-24 17:32:12', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:32:13', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926209821892157440, 'active_mq_queue_test', '20250524010', '127.0.0.1', 'SYS', '2025-05-24 17:33:03', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:33:03', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926211633726308352, 'active_mq_queue_test', '20250524011', '127.0.0.1', 'SYS', '2025-05-24 17:40:15', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:40:16', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926211704379359232, 'active_mq_broadcast_test', '20250524012', '127.0.0.1', 'SYS', '2025-05-24 17:40:32', '{\"value\":\"12333\"}', '01', 3, NULL, '2025-05-24 17:40:32', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926212538735915008, 'active_mq_broadcast_test', '20250524013', '127.0.0.1', 'SYS', '2025-05-24 17:43:51', '{\"value\":\"232\"}', '01', 3, NULL, '2025-05-24 17:43:51', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926214053944524800, 'active_mq_broadcast_test', '20250524014', '127.0.0.1', 'SYS', '2025-05-24 17:49:52', '{\"value\":\"232\"}', '01', 3, NULL, '2025-05-24 17:49:53', NULL, '2025-05-25 11:55:36', NULL, NULL);
INSERT INTO `pserv_ebus_event` (`id`, `topic_no`, `event_key`, `provider_ip`, `provider_sys_name`, `provider_time`, `event_msg`, `status`, `retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926214141014081536, 'active_mq_queue_test', '20250524015', '127.0.0.1', 'SYS', '2025-05-24 17:50:13', '{\"value\":\"2345\"}', '01', 3, NULL, '2025-05-24 17:50:13', NULL, '2025-05-25 11:55:36', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_ebus_event_ack
-- ----------------------------
DROP TABLE IF EXISTS `pserv_ebus_event_ack`;
CREATE TABLE `pserv_ebus_event_ack` (
  `id` bigint NOT NULL COMMENT '主键',
  `event_id` bigint DEFAULT NULL COMMENT '事件id',
  `event_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消息唯一key，幂等',
  `consumer_ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消费者ip',
  `consumer_sys_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消费者系统名称 ',
  `ack_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消费者ACK时间',
  `result_flag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT ' INIT-初始化 SUCC-成功 FAIL-失败',
  `notes` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='平台服务-EBUS-事件消费回执';

-- ----------------------------
-- Records of pserv_ebus_event_ack
-- ----------------------------
BEGIN;
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925541528034369536, NULL, '20250522001', '', '', '20250522211729', 'SUCC', NULL, '2025-05-22 21:17:30', NULL, '2025-05-22 21:17:30', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925542852696236032, NULL, '20250522002', '', '', '20250522212245', 'SUCC', NULL, '2025-05-22 21:22:46', NULL, '2025-05-22 21:22:57', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925543326648487936, NULL, '20250522003', '', '', '20250522212438', 'SUCC', NULL, '2025-05-22 21:24:39', NULL, '2025-05-22 21:24:39', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1925543326778511360, NULL, '20250522003', '', '', '20250522212438', 'SUCC', NULL, '2025-05-22 21:24:39', NULL, '2025-05-22 21:24:39', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487243480915968, NULL, '20250522001', '127.0.0.1', 'app-bond', '20250525115525', 'SUCC', NULL, '2025-05-25 11:55:26', NULL, '2025-05-25 11:55:26', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487244244279296, NULL, '20250522002', '127.0.0.1', 'app-bond', '20250525115526', 'SUCC', NULL, '2025-05-25 11:55:26', NULL, '2025-05-25 11:55:26', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487244600795136, NULL, '20250522003', '127.0.0.1', 'app-bond-1', '20250525115526', 'SUCC', NULL, '2025-05-25 11:55:26', NULL, '2025-05-25 11:55:26', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487244667904000, NULL, '20250522003', '127.0.0.1', 'app-bond-2', '20250525115526', 'SUCC', NULL, '2025-05-25 11:55:26', NULL, '2025-05-25 11:55:26', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487260904054784, NULL, '20250522001', '127.0.0.1', 'app-bond', '20250525115530', 'SUCC', NULL, '2025-05-25 11:55:30', NULL, '2025-05-25 11:55:30', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487261176684544, NULL, '20250522002', '127.0.0.1', 'app-bond', '20250525115530', 'SUCC', NULL, '2025-05-25 11:55:30', NULL, '2025-05-25 11:55:30', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487261461897216, NULL, '20250522003', '127.0.0.1', 'app-bond-1', '20250525115530', 'SUCC', NULL, '2025-05-25 11:55:30', NULL, '2025-05-25 11:55:30', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487261503840256, NULL, '20250522003', '127.0.0.1', 'app-bond-2', '20250525115530', 'SUCC', NULL, '2025-05-25 11:55:30', NULL, '2025-05-25 11:55:30', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487281867186176, NULL, '20250522001', '127.0.0.1', 'app-bond', '20250525115535', 'SUCC', NULL, '2025-05-25 11:55:35', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487282144010240, NULL, '20250522002', '127.0.0.1', 'app-bond', '20250525115535', 'SUCC', NULL, '2025-05-25 11:55:35', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487282412445696, NULL, '20250522003', '127.0.0.1', 'app-bond-1', '20250525115535', 'SUCC', NULL, '2025-05-25 11:55:35', NULL, '2025-05-25 11:55:35', NULL, NULL);
INSERT INTO `pserv_ebus_event_ack` (`id`, `event_id`, `event_key`, `consumer_ip`, `consumer_sys_name`, `ack_time`, `result_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1926487282458583040, NULL, '20250522003', '127.0.0.1', 'app-bond-2', '20250525115535', 'SUCC', NULL, '2025-05-25 11:55:35', NULL, '2025-05-25 11:55:35', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_ebus_topic
-- ----------------------------
DROP TABLE IF EXISTS `pserv_ebus_topic`;
CREATE TABLE `pserv_ebus_topic` (
  `id` bigint NOT NULL COMMENT '主键',
  `topic_no` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '主题编号',
  `topic_name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '主题名称',
  `topic_channel` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '投递渠道:spring_event , active_mq',
  `publish_type` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '投递类型： queue-队列 broadcast-广播',
  `status` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '00-启用 01-停用',
  `max_retry_num` int DEFAULT NULL COMMENT '最大重试次数 默认：5，0不重试',
  `notes` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='平台服务-EBUS-事件主题';

-- ----------------------------
-- Records of pserv_ebus_topic
-- ----------------------------
BEGIN;
INSERT INTO `pserv_ebus_topic` (`id`, `topic_no`, `topic_name`, `topic_channel`, `publish_type`, `status`, `max_retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 'spring_event_queue_test', 'SpringEventQueue测试', 'spring_event', 'queue', '00', 3, NULL, NULL, NULL, '2025-05-25 03:05:20', NULL, NULL);
INSERT INTO `pserv_ebus_topic` (`id`, `topic_no`, `topic_name`, `topic_channel`, `publish_type`, `status`, `max_retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (2, 'spring_event_broadcast_test', 'SpringEventBroadcast测试', 'spring_event', 'broadcast', '00', 3, NULL, NULL, NULL, '2025-05-25 03:05:20', NULL, NULL);
INSERT INTO `pserv_ebus_topic` (`id`, `topic_no`, `topic_name`, `topic_channel`, `publish_type`, `status`, `max_retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (3, 'active_mq_queue_test', 'ActiveMqQueue测试', 'active_mq', 'queue', '00', 3, NULL, NULL, NULL, '2025-05-25 03:05:20', NULL, NULL);
INSERT INTO `pserv_ebus_topic` (`id`, `topic_no`, `topic_name`, `topic_channel`, `publish_type`, `status`, `max_retry_num`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (4, 'active_mq_broadcast_test', 'ActiveMqBroadcast测试', 'active_mq', 'broadcast', '00', 3, NULL, NULL, NULL, '2025-05-25 03:05:20', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_data_rule
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_data_rule`;
CREATE TABLE `pserv_uacs_data_rule` (
  `id` bigint NOT NULL COMMENT '主键',
  `data_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据表',
  `data_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据表名称',
  `data_dimension` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据表维度字段',
  `data_dimension_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据表维度字段名称',
  `data_rule_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据规则名称',
  `rule_logic` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '规则逻辑：1-等于 2-不等于 3-大于 4-小于 5-大于等于 6-小于等于 7-包含 8-不包含 9-在列表中 10-不在列表中',
  `rule_value_source` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '逻辑值来源： 1-后台维护 2-系统数据源 3-系统提供',
  `rule_value` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '逻辑值',
  `rule_source_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '获取数据源列表的URL',
  `rule_value_provider` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '系统数据值提供器全类名',
  `value_type` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '1-字符串 2-数字',
  `value_struct` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '1-单值 2-列表 3-字典',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-岗位数据权限规则';

-- ----------------------------
-- Records of pserv_uacs_data_rule
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_data_rule` (`id`, `data_table`, `data_table_name`, `data_dimension`, `data_dimension_name`, `data_rule_name`, `rule_logic`, `rule_value_source`, `rule_value`, `rule_source_url`, `rule_value_provider`, `value_type`, `value_struct`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 'pserv_uacs_tenant_department', '组织机构表', 'tenant_id', '租户id', '[组织机构表.租户id] = [当前用户租户]', '1', '3', NULL, NULL, 'userTenantSysRuleValueProvider', '2', '1', NULL, '2025-05-16 06:05:15', 0, '2025-05-21 05:21:49', NULL, NULL);
INSERT INTO `pserv_uacs_data_rule` (`id`, `data_table`, `data_table_name`, `data_dimension`, `data_dimension_name`, `data_rule_name`, `rule_logic`, `rule_value_source`, `rule_value`, `rule_source_url`, `rule_value_provider`, `value_type`, `value_struct`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (2, 'pserv_uacs_tenant_department', '组织机构表', 'id', '组织机构id', '[组织机构表.组织机构id] in [当前用户组织机构以及子机构]', '9', '3', NULL, NULL, 'userDepartmentSysRuleValueProvider', '2', '2', NULL, '2025-05-16 06:05:15', 0, '2025-05-21 05:21:54', NULL, NULL);
INSERT INTO `pserv_uacs_data_rule` (`id`, `data_table`, `data_table_name`, `data_dimension`, `data_dimension_name`, `data_rule_name`, `rule_logic`, `rule_value_source`, `rule_value`, `rule_source_url`, `rule_value_provider`, `value_type`, `value_struct`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (3, 'pserv_uacs_tenant_department_post', '岗位表', 'department_id', '组织机构id', '[岗位表.组织机构id] in [当前用户组织机构以及子机构]', '9', '3', NULL, NULL, 'userDepartmentSysRuleValueProvider', '2', '2', NULL, '2025-05-16 06:05:15', 0, '2025-05-21 05:23:18', NULL, NULL);
INSERT INTO `pserv_uacs_data_rule` (`id`, `data_table`, `data_table_name`, `data_dimension`, `data_dimension_name`, `data_rule_name`, `rule_logic`, `rule_value_source`, `rule_value`, `rule_source_url`, `rule_value_provider`, `value_type`, `value_struct`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (10, 'pserv_uacs_view_tenant_department_user', '部门用户视图', 'department_id', '机构id', '[部门用户视图.组织机构id] in [当前用户组织机构以及子机构]', '9', '3', NULL, NULL, 'userDepartmentSysRuleValueProvider', '2', '2', NULL, '2025-05-16 06:05:15', 0, '2025-05-21 05:23:22', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_plate_res
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_plate_res`;
CREATE TABLE `pserv_uacs_plate_res` (
  `id` bigint NOT NULL COMMENT '主键',
  `pid` bigint DEFAULT NULL COMMENT '父节点id',
  `res_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '资源名称',
  `res_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '资源类型： 00-菜单 01-操作按钮(接口) 02-权限码',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '请求地址',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限码',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图标',
  `order_no` int DEFAULT '0' COMMENT '排序',
  `leaf_flag` tinyint(1) DEFAULT '1' COMMENT '是否是叶子节点',
  `router` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '路由',
  `meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '元数据',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-应用资源表';

-- ----------------------------
-- Records of pserv_uacs_plate_res
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 0, '全资源权限', '01', '/**', 'ALL', NULL, 0, 1, '0,1', NULL, NULL, '2024-05-10 13:38:32', 0, '2024-06-01 01:22:01', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (100, 0, '工作台', '00', '/workbench', NULL, NULL, 0, 0, '0,100', '{\n    \"title\":\n    {\n        \"zh_CN\": \"工作台\",\n        \"en_US\": \"Workbench\"\n    },\n    \"icon\": \"dashboard\",\n    \"component\": \"LAYOUT\",\n    \"name\": \"Workbench\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-11-15 11:39:57', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101, 0, '权限中心', '00', '/uacs', NULL, NULL, 2, 0, '0,101', '{\n    \"title\":\n    {\n        \"zh_CN\": \"权限中心\",\n        \"en_US\": \"Permission Center\"\n    },\n    \"icon\": \"system-setting\",\n    \"component\": \"LAYOUT\",\n    \"name\": \"uacs\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-10-23 01:58:20', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (102, 0, '基础能力', '00', '/basic', NULL, NULL, 1, 0, '0,102', '{\n    \"title\":\n    {\n        \"zh_CN\": \"基础能力\",\n        \"en_US\": \"Basic Competency\"\n    },\n    \"icon\": \"system-components\",\n    \"component\": \"LAYOUT\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-10-13 01:57:47', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (100001, 100, '欢迎页面', '00', '/workbench/welcome', NULL, NULL, 1, 0, '0,100,100001', '{\n    \"title\":\n    {\n        \"zh_CN\": \"欢迎使用\",\n        \"en_US\": \"Welcome\"\n    },\n    \"component\": \"/workbench/welcome/index\",\n		\"name\": \"WorkbenchWelcome\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-11-26 07:07:07', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101001, 101, '租户管理', '00', '/uacs/tenant', NULL, NULL, 1, 0, '0,101,101001', '{\n    \"title\":\n    {\n        \"zh_CN\": \"租户管理\",\n        \"en_US\": \"Tenant Mgr\"\n    },\n    \"component\": \"/uacs/tenant/index\",\n    \"name\": \"UacsTenant\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-16 15:01:29', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101002, 101, '用户管理', '00', '/uacs/user', NULL, NULL, 7, 0, '0,101,101002', '{\n    \"title\":\n    {\n        \"zh_CN\": \"用户管理\",\n        \"en_US\": \"User Mgr\"\n    },\n    \"component\": \"/uacs/user/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-11-28 09:26:17', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101003, 101, '资源管理', '00', '/uacs/res', NULL, NULL, 3, 0, '0,101,101003', '{\n    \"title\":\n    {\n        \"zh_CN\": \"资源管理\",\n        \"en_US\": \"Resource Mgr\"\n    },\n    \"component\": \"/uacs/resource/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-16 01:03:46', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101004, 101, '角色管理', '00', '/uacs/role', NULL, NULL, 4, 0, '0,101,101004', '{\n    \"title\":\n    {\n        \"zh_CN\": \"角色管理\",\n        \"en_US\": \"Role Mgr\"\n    },\n    \"component\": \"/uacs/role/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-16 01:03:52', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101005, 101, '组织机构管理', '00', '/uacs/department', NULL, NULL, 2, 0, '0,101,101005', '{\n    \"title\":\n    {\n        \"zh_CN\": \"组织机构管理\",\n        \"en_US\": \"Department Mgr\"\n    },\n    \"component\": \"/uacs/department/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-24 07:04:02', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101006, 101, '岗位管理', '00', '/uacs/post', NULL, NULL, 5, 0, '0,101,101006', '{\n    \"title\":\n    {\n        \"zh_CN\": \"岗位管理\",\n        \"en_US\": \"Post Mgr\"\n    },\n    \"component\": \"/uacs/post/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-11-28 09:26:20', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (101007, 101, '数据规则管理', '00', '/uacs/data-rule', NULL, NULL, 6, 0, '0,101,101007', '{\n    \"title\":\n    {\n        \"zh_CN\": \"数据规则配置\",\n        \"en_US\": \"Data Rule Mgr\"\n    },\n    \"component\": \"/uacs/data-rule/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-11-28 09:26:24', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (102001, 102, '系统配置', '00', '/basic/sys-config', NULL, NULL, 1, 0, '0,102,102001', '{\n    \"title\":\n    {\n        \"zh_CN\": \"系统配置\",\n        \"en_US\": \"System Config\"\n    },\n    \"component\": \"/basic/sys-config/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-16 01:04:16', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (102002, 102, '字典管理', '00', '/basic/dict', NULL, NULL, 2, 0, '0,102,102002', '{\n    \"title\":\n    {\n        \"zh_CN\": \"字典管理\",\n        \"en_US\": \"Dict Mgr\"\n    },\n    \"component\": \"/basic/dict/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-16 01:04:22', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (102003, 102, '代码逆向工具', '00', '/basic/code-gen', NULL, NULL, 3, 0, '0,102,102003', '{\n    \"title\":\n    {\n        \"zh_CN\": \"代码生成\",\n        \"en_US\": \"Code Gen\"\n    },\n    \"component\": \"/basic/code-gen/index\"\n}', NULL, '2024-06-01 09:22:11', 0, '2024-09-18 01:40:30', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010010001, 101001, '创建租户信息', '01', '/api/forge/plate/v1/uacs/plate_tenant/create', '', '', 1, 1, '0,101,101001,1010010001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010010002, 101001, '删除租户信息', '01', '/api/forge/plate/v1/uacs/plate_tenant/delete/{tenantId}', '', '', 2, 1, '0,101,101001,1010010002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010010003, 101001, '修改租户信息', '01', '/api/forge/plate/v1/uacs/plate_tenant/update', '', '', 3, 1, '0,101,101001,1010010003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010010004, 101001, '查询租户信息（分页）', '01', '/api/forge/plate/v1/uacs/plate_tenant/query/page', '', '', 4, 1, '0,101,101001,1010010004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010010005, 101001, '查询租户信息（不分页）', '01', '/api/forge/plate/v1/uacs/plate_tenant/query/list', '', '', 5, 1, '0,101,101001,1010010005', '', '', '2024-06-01 09:22:11', 0, '2024-12-24 05:59:12', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020001, 101002, '平台用户管理查询信息列表（分页）', '01', '/api/forge/plate/v1/uacs/palte_user/query/page', '', '', 1, 1, '0,101,101002,1010020001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020002, 101002, '平台用户管理查询信息列表（不分页）', '01', '/api/forge/plate/v1/uacs/palte_user/query/list', '', '', 2, 1, '0,101,101002,1010020002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020003, 101002, '平台用户创建', '01', '/api/forge/plate/v1/uacs/palte_user/create', '', '', 3, 1, '0,101,101002,1010020003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020004, 101002, '平台用户更新', '01', '/api/forge/plate/v1/uacs/palte_user/update', '', '', 4, 1, '0,101,101002,1010020004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020005, 101002, '平台用户删除', '01', '/api/forge/plate/v1/uacs/palte_user/delete/{id}', '', '', 5, 1, '0,101,101002,1010020005', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020006, 101002, '保存用户岗位关系', '01', '/api/forge/plate/v1/uacs/palte_user/post_ref/save', '', '', 6, 1, '0,101,101002,1010020006', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010020007, 101002, '获取用户绑定的岗位', '01', '/api/forge/plate/v1/uacs/palte_user/building/post/{userId}', '', '', 7, 1, '0,101,101002,1010020007', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030001, 101003, '创建资源', '01', '/api/forge/plate/v1/uacs/plate_res/create', '', '', 1, 1, '0,101,101003,1010030001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030002, 101003, '删除资源', '01', '/api/forge/plate/v1/uacs/plate_res/delete/{resId}', '', '', 2, 1, '0,101,101003,1010030002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030003, 101003, '资源更新', '01', '/api/forge/plate/v1/uacs/plate_res/update', '', '', 3, 1, '0,101,101003,1010030003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030004, 101003, '资源查询（分页）', '01', '/api/forge/plate/v1/uacs/plate_res/query/page', '', '', 4, 1, '0,101,101003,1010030004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030005, 101003, '资源查询（不分页）', '01', '/api/forge/plate/v1/uacs/plate_res/query/list', '', '', 5, 1, '0,101,101003,1010030005', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030006, 101003, '资源查询（树结构）', '01', '/api/forge/plate/v1/uacs/plate_res/query/tree', '', '', 6, 1, '0,101,101003,1010030006', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010030007, 101003, '资源查询（级联结构）', '01', '/api/forge/plate/v1/uacs/plate_res/query/cascader', '', '', 7, 1, '0,101,101003,1010030007', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040001, 101004, '新建角色信息', '01', '/api/forge/plate/v1/uacs/plate_role/create', '', '', 1, 1, '0,101,101004,1010040001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040002, 101004, '删除角色信息', '01', '/api/forge/plate/v1/uacs/plate_role/delete/{roleId}', '', '', 2, 1, '0,101,101004,1010040002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040003, 101004, '更新角色信息', '01', '/api/forge/plate/v1/uacs/plate_role/update', '', '', 3, 1, '0,101,101004,1010040003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040004, 101004, '查询角色信息（分页）', '01', '/api/forge/plate/v1/uacs/plate_role/query/page', '', '', 4, 1, '0,101,101004,1010040004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040005, 101004, '查询角色信息（不分页）', '01', '/api/forge/plate/v1/uacs/plate_role/query/list', '', '', 5, 1, '0,101,101004,1010040005', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040006, 101004, '保存角色和资源关系', '01', '/api/forge/plate/v1/uacs/plate_role/res_ref/save', '', '', 6, 1, '0,101,101004,1010040006', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010040007, 101004, '获取角色绑定的资源列表', '01', '/api/forge/plate/v1/uacs/plate_role/building/res_list/{roleId}', '', '', 7, 1, '0,101,101004,1010040007', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010050001, 101005, '创建组织机构信息', '01', '/api/forge/plate/v1/uacs/tenant_department/create', '', '', 1, 1, '0,101,101005,1010050001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010050002, 101005, '删除组织机构信息', '01', '/api/forge/plate/v1/uacs/tenant_department/delete/{tenantDepartmentId}', '', '', 2, 1, '0,101,101005,1010050002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010050003, 101005, '修改组织机构信息', '01', '/api/forge/plate/v1/uacs/tenant_department/update', '', '', 3, 1, '0,101,101005,1010050003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010050004, 101005, '查询组织机构信息（分页）', '01', '/api/forge/plate/v1/uacs/tenant_department/query/page', '', '', 4, 1, '0,101,101005,1010050004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010050005, 101005, '查询组织机构信息（不分页）', '01', '/api/forge/plate/v1/uacs/tenant_department/query/list', '', '', 5, 1, '0,101,101005,1010050005', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010050006, 101005, '查询组织机构级联选择列表', '01', '/api/forge/plate/v1/uacs/tenant_department/query/cascader', '', '', 6, 1, '0,101,101005,1010050006', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060001, 101006, '岗位创建', '01', '/api/forge/plate/v1/uacs/tenant_department_post/create', '', '', 1, 1, '0,101,101006,1010060001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060002, 101006, '岗位删除', '01', '/api/forge/plate/v1/uacs/tenant_department_post/delete/{postId}', '', '', 2, 1, '0,101,101006,1010060002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060003, 101006, '岗位修改', '01', '/api/forge/plate/v1/uacs/tenant_department_post/update', '', '', 3, 1, '0,101,101006,1010060003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060004, 101006, '岗位查询（分页）', '01', '/api/forge/plate/v1/uacs/tenant_department_post/query/page', '', '', 4, 1, '0,101,101006,1010060004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060005, 101006, '岗位查询（不分页）', '01', '/api/forge/plate/v1/uacs/tenant_department_post/query/list', '', '', 5, 1, '0,101,101006,1010060005', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060006, 101006, '岗位角色关系保存', '01', '/api/forge/plate/v1/uacs/tenant_department_post/role_ref/save', '', '', 6, 1, '0,101,101006,1010060006', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060007, 101006, '岗位数据规则保存', '01', '/api/forge/plate/v1/uacs/tenant_department_post/data_rule_ref/save', '', '', 7, 1, '0,101,101006,1010060007', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060008, 101006, '获取岗位绑定的角色列表', '01', '/api/forge/plate/v1/uacs/tenant_department_post/building/role_list/{postId}', '', '', 8, 1, '0,101,101006,1010060008', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010060009, 101006, '获取岗位绑定的数据规则列表', '01', '/api/forge/plate/v1/uacs/tenant_department_post/building/data_rule_list/{postId}', '', '', 9, 1, '0,101,101006,1010060009', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010070001, 101007, '创建数据规则', '01', '/api/forge/plate/v1/uacs/data_rule/create', '', '', 1, 1, '0,101,101007,1010070001', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010070002, 101007, '删除数据规则', '01', '/api/forge/plate/v1/uacs/data_rule/delete/{dataRuleId}', '', '', 2, 1, '0,101,101007,1010070002', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010070003, 101007, '修改数据规则', '01', '/api/forge/plate/v1/uacs/data_rule/update', '', '', 3, 1, '0,101,101007,1010070003', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010070004, 101007, '查询数据规则（分页）', '01', '/api/forge/plate/v1/uacs/data_rule/query/page', '', '', 4, 1, '0,101,101007,1010070004', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_res` (`id`, `pid`, `res_name`, `res_type`, `url`, `code`, `icon`, `order_no`, `leaf_flag`, `router`, `meta`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1010070005, 101007, '查询数据规则（不分页）', '01', '/api/forge/plate/v1/uacs/data_rule/query/list', '', '', 5, 1, '0,101,101007,1010070005', '', '', '2024-06-01 09:22:11', 0, '2024-11-24 06:29:40', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_plate_role
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_plate_role`;
CREATE TABLE `pserv_uacs_plate_role` (
  `id` bigint NOT NULL COMMENT '主键',
  `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色名称',
  `role_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色编号',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-应用角色表';

-- ----------------------------
-- Records of pserv_uacs_plate_role
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_plate_role` (`id`, `role_name`, `role_no`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, '系统管理员', 'PRN000000', NULL, '2024-05-10 13:38:32', 0, '2025-05-08 13:38:55', NULL, NULL);
INSERT INTO `pserv_uacs_plate_role` (`id`, `role_name`, `role_no`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923248313776332800, '学校本部管理员', 'PRN0001000002', NULL, '2025-05-16 13:25:05', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_role` (`id`, `role_name`, `role_no`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923249655123140608, '学院管理员', 'PRN0001000003', NULL, '2025-05-16 13:30:25', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_role` (`id`, `role_name`, `role_no`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923249698148311040, '班级管理员', 'PRN0001000004', NULL, '2025-05-16 13:30:35', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_plate_role_res_ref
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_plate_role_res_ref`;
CREATE TABLE `pserv_uacs_plate_role_res_ref` (
  `id` bigint NOT NULL COMMENT '主键',
  `role_id` bigint DEFAULT NULL COMMENT '角色id',
  `res_id` bigint DEFAULT NULL COMMENT '资源id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-角色资源关系表';

-- ----------------------------
-- Records of pserv_uacs_plate_role_res_ref
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1, 1, 1);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343278913110016, 1923248313776332800, 100);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343278946664448, 1923248313776332800, 100001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343278976024576, 1923248313776332800, 101);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279013773312, 1923248313776332800, 101005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279038939136, 1923248313776332800, 1010050001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279076687872, 1923248313776332800, 1010050002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279106048000, 1923248313776332800, 1010050003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279143796736, 1923248313776332800, 1010050004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279173156864, 1923248313776332800, 1010050005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279210905600, 1923248313776332800, 1010050006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279240265728, 1923248313776332800, 1010040004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279265431552, 1923248313776332800, 1010040005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279307374592, 1923248313776332800, 1010040006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279336734720, 1923248313776332800, 1010040007);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279374483456, 1923248313776332800, 101006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279403843584, 1923248313776332800, 1010060001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279441592320, 1923248313776332800, 1010060002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279466758144, 1923248313776332800, 1010060003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279508701184, 1923248313776332800, 1010060004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279538061312, 1923248313776332800, 1010060005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279575810048, 1923248313776332800, 1010060006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279609364480, 1923248313776332800, 1010060007);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279642918912, 1923248313776332800, 1010060008);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279672279040, 1923248313776332800, 1010060009);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279718416384, 1923248313776332800, 1010070004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279764553728, 1923248313776332800, 1010070005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279806496768, 1923248313776332800, 101002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279856828416, 1923248313776332800, 1010020001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279907160064, 1923248313776332800, 1010020002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343279965880320, 1923248313776332800, 1010020003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343280020406272, 1923248313776332800, 1010020004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343280066543616, 1923248313776332800, 1010020005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343280121069568, 1923248313776332800, 1010020006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343280158818304, 1923248313776332800, 1010020007);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333464227840, 1923249655123140608, 100);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333497782272, 1923249655123140608, 100001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333535531008, 1923249655123140608, 101);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333569085440, 1923249655123140608, 101005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333602639872, 1923249655123140608, 1010050001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333636194304, 1923249655123140608, 1010050002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333665554432, 1923249655123140608, 1010050003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333694914560, 1923249655123140608, 1010050004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333728468992, 1923249655123140608, 1010050005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333757829120, 1923249655123140608, 1010050006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333795577856, 1923249655123140608, 1010040004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333824937984, 1923249655123140608, 1010040005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333858492416, 1923249655123140608, 1010040006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333887852544, 1923249655123140608, 1010040007);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333925601280, 1923249655123140608, 101006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333954961408, 1923249655123140608, 1010060001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343333988515840, 1923249655123140608, 1010060002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334022070272, 1923249655123140608, 1010060003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334051430400, 1923249655123140608, 1010060004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334080790528, 1923249655123140608, 1010060005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334114344960, 1923249655123140608, 1010060006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334147899392, 1923249655123140608, 1010060007);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334177259520, 1923249655123140608, 1010060008);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334210813952, 1923249655123140608, 1010060009);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334240174080, 1923249655123140608, 1010070004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334273728512, 1923249655123140608, 1010070005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334303088640, 1923249655123140608, 101002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334336643072, 1923249655123140608, 1010020001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334370197504, 1923249655123140608, 1010020002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334403751936, 1923249655123140608, 1010020003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334437306368, 1923249655123140608, 1010020004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334475055104, 1923249655123140608, 1010020005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334504415232, 1923249655123140608, 1010020006);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923343334537969664, 1923249655123140608, 1010020007);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212024115200, 1923249698148311040, 100);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212061863936, 1923249698148311040, 100001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212095418368, 1923249698148311040, 101);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212133167104, 1923249698148311040, 1010060004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212166721536, 1923249698148311040, 1010060005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212204470272, 1923249698148311040, 101002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212242219008, 1923249698148311040, 1010020001);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212275773440, 1923249698148311040, 1010020002);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212300939264, 1923249698148311040, 1010020003);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212338688000, 1923249698148311040, 1010020004);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212363853824, 1923249698148311040, 1010020005);
INSERT INTO `pserv_uacs_plate_role_res_ref` (`id`, `role_id`, `res_id`) VALUES (1923344212397408256, 1923249698148311040, 1010020007);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_plate_tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_plate_tenant_info`;
CREATE TABLE `pserv_uacs_plate_tenant_info` (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户编号',
  `tenant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `contacts_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系人',
  `contacts_email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系邮箱',
  `contacts_phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系电话',
  `active_flag` tinyint(1) DEFAULT NULL COMMENT '是否可用',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-租户信息';

-- ----------------------------
-- Records of pserv_uacs_plate_tenant_info
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_plate_tenant_info` (`id`, `tenant_no`, `tenant_name`, `contacts_name`, `contacts_email`, `contacts_phone`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 'PTN000000', '技术锻造开发平台', 'LH0811', '123@qq.com', '13000000001', 1, '系统默认', '2025-05-08 21:14:00', 9999, '2025-05-14 12:51:40', NULL, NULL);
INSERT INTO `pserv_uacs_plate_tenant_info` (`id`, `tenant_no`, `tenant_name`, `contacts_name`, `contacts_email`, `contacts_phone`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1922608866285805568, 'PTN0001000004', '青岛科技大学', '小C', '13000000000@qq.com', '13000000000', 1, NULL, '2025-05-14 19:04:09', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_tenant_info` (`id`, `tenant_no`, `tenant_name`, `contacts_name`, `contacts_email`, `contacts_phone`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1922608908870574080, 'PTN0001000005', '青岛大学', '小D', '13000000000@qq.com', '13000000000', 1, NULL, '2025-05-14 19:04:19', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_plate_user
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_plate_user`;
CREATE TABLE `pserv_uacs_plate_user` (
  `id` bigint NOT NULL COMMENT '主键',
  `plate_user_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '平台用户编号',
  `nick_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  `real_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '真实姓名',
  `id_card_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '证件号',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号',
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  `salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码盐',
  `birthday` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生日',
  `gender` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '性别： 00-保密 01-男 02-女',
  `avatar_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '头像',
  `real_name_flag` tinyint(1) DEFAULT NULL COMMENT '是否实名认证',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后一次登录时间',
  `active_flag` tinyint(1) DEFAULT NULL COMMENT '是否可用',
  `write_off_flag` tinyint(1) DEFAULT NULL COMMENT '是否注销',
  `default_tenant_id` bigint DEFAULT NULL COMMENT '默认租户',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-平台用户表';

-- ----------------------------
-- Records of pserv_uacs_plate_user
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 'PUN000000001', 'LH0811', 'LH0811', NULL, 'SysAdmin', '$2a$10$mrwdGSwdXjgFxBsWkIIzQebyi1K54ORH37NsKxdo96g1CK68r4pK.', '$2a$10$mrwdGSwdXjgFxBsWkIIzQe', NULL, '00', NULL, 1, '2024-05-09 15:11:37', 1, 0, 1, NULL, '2024-05-09 15:11:44', 0, '2025-05-14 22:16:34', 1, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923013599480082432, 'PUN0001000002', '青岛大学校长', '青岛大学校长', NULL, '15000001001', '$2a$10$8gHOUkAPwrnw6vVjJgjlDOkEZAP3CfvX1wk0OOXEysSkp9A5GZnN6', '$2a$10$8gHOUkAPwrnw6vVjJgjlDO', '1979-05-10', '00', NULL, 0, '2025-05-15 21:52:25', 1, 0, 1922608908870574080, NULL, '2025-05-15 21:52:25', 1, '2025-05-16 14:55:07', NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923014066587136000, 'PUN0001000003', '青岛大学计算机学院主任', '青岛大学计算机学院主任', NULL, '15000001002', '$2a$10$XLXIsrMFD9BeR9j4s/8/fO3aFg2GizZxgPPj.QK3ZktTc/J/bTBYO', '$2a$10$XLXIsrMFD9BeR9j4s/8/fO', '2007-05-09', '00', NULL, 0, '2025-05-15 21:54:16', 1, 0, 1922608908870574080, NULL, '2025-05-15 21:54:16', 1, '2025-05-16 19:43:31', 1, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923014309210845184, 'PUN0001000004', '青岛大学数学学院主任', '青岛大学数学学院主任', NULL, '15000001003', '$2a$10$8xY1JlA6ezVGJfpL3.biXeYa5u5IQbJHqOPdcTpGGckdDt1UMaIQy', '$2a$10$8xY1JlA6ezVGJfpL3.biXe', '2007-05-09', '00', NULL, 0, '2025-05-15 21:55:14', 1, 0, NULL, NULL, '2025-05-15 21:55:14', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923245370658381824, 'PUN0001000005', '(青大)2025级-计算机科学与技术班主任', '(青大)2025级-计算机科学与技术班主任', NULL, '15000001004', '$2a$10$aIVBThaGJiSnbhePr5LKO.rrFZJcjB4twpqoAQftGRalhzYz3V3lK', '$2a$10$aIVBThaGJiSnbhePr5LKO.', '2025-05-28', '00', NULL, 0, '2025-05-16 13:13:23', 1, 0, 1922608908870574080, NULL, '2025-05-16 13:13:23', 1, '2025-05-16 19:44:12', 1, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923245449976864768, 'PUN0001000006', '(青大)2025级-应用数学班主任', '(青大)2025级-应用数学班主任', NULL, '15000001005', '$2a$10$vw4k75KOcbX1qxzV.8LGnOeNlGq3n2IhYP/bjDBIdpuuwY78/jzjy', '$2a$10$vw4k75KOcbX1qxzV.8LGnO', '2025-05-28', '00', NULL, 0, '2025-05-16 13:13:42', 1, 0, NULL, NULL, '2025-05-16 13:13:42', 1, '2025-05-16 13:20:13', 1, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923245539164545024, 'PUN0001000007', '(青大)2024级-应用数学班主任', '(青大)2024级-应用数学班主任', NULL, '15000001006', '$2a$10$V73ENuVfCiR/LjrmaZeGze3WWsnn1SXVjOimt.650wBp8rav3nU3m', '$2a$10$V73ENuVfCiR/LjrmaZeGze', '2025-05-28', '00', NULL, 0, '2025-05-16 13:14:04', 1, 0, NULL, NULL, '2025-05-16 13:14:04', 1, '2025-05-16 13:20:08', 1, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923245596249022464, 'PUN0001000008', '(青大)2024级-计算机科学与技术班主任', '(青大)2024级-计算机科学与技术班主任', NULL, '15000001007', '$2a$10$bHceWPEZMBIPNwh8M86JUuEPIwVoE..pFbz60sWs8VCxm0E6RUFCG', '$2a$10$bHceWPEZMBIPNwh8M86JUu', '2025-05-28', '00', NULL, 0, '2025-05-16 13:14:17', 1, 0, NULL, NULL, '2025-05-16 13:14:17', 1, '2025-05-16 13:20:02', 1, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923247317339725824, 'PUN0001000009', '青岛科技大学校长', '青岛科技大学校长', NULL, '15000002001', '$2a$10$r7j7X0zFoY081hPa6kEjj.7wjzjf1YLd/vP4rqvJNHpCB8T0VckXC', '$2a$10$r7j7X0zFoY081hPa6kEjj.', '2025-05-28', '00', NULL, 0, '2025-05-16 13:21:07', 1, 0, 1922608866285805568, NULL, '2025-05-16 13:21:07', 1, '2025-05-18 17:33:34', NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923247403025162240, 'PUN0001000010', '青岛科技大学计算机学院主任', '青岛科技大学计算机学院主任', NULL, '15000002002', '$2a$10$LoDZgKq30XWbbETil8Gt9.m/Oe9hB9pwyWvkP/XkJjM76DamUXu9.', '$2a$10$LoDZgKq30XWbbETil8Gt9.', '2025-05-28', '00', NULL, 0, '2025-05-16 13:21:28', 1, 0, 1922608866285805568, NULL, '2025-05-16 13:21:28', 1, '2025-05-18 17:34:38', NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923247514119692288, 'PUN0001000011', '青岛科技大学生物学院主任', '青岛科技大学生物学院主任', NULL, '15000002003', '$2a$10$wBtc2wcUsbkGnYZZJKqVxeB05U5FXBKZ9NUBrV5cMSZrvAQfWGTZC', '$2a$10$wBtc2wcUsbkGnYZZJKqVxe', '2025-05-28', '00', NULL, 0, '2025-05-16 13:21:54', 1, 0, NULL, NULL, '2025-05-16 13:21:54', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923247636501094400, 'PUN0001000012', '(青科)2025级-计算机科学与技术班主任', '(青科)2025级-计算机科学与技术班主任', NULL, '15000002004', '$2a$10$0gSjbUGud1r3m1Fmu/z1c.ahSeTdrpCjyUCsRyLnOw83zFAsI14yK', '$2a$10$0gSjbUGud1r3m1Fmu/z1c.', '2025-05-28', '00', NULL, 0, '2025-05-16 13:22:24', 1, 0, 1922608866285805568, NULL, '2025-05-16 13:22:24', 1, '2025-05-18 17:41:22', NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923247734840745984, 'PUN0001000013', '(青科)2025级-应用生物技术班主任', '(青科)2025级-应用生物技术班主任', NULL, '15000002005', '$2a$10$1rPToL5fZ/1ilZ2scuw9TOyTuLKP1zwpxKy0b4e.is21kuJ2m92VK', '$2a$10$1rPToL5fZ/1ilZ2scuw9TO', '2025-05-28', '00', NULL, 0, '2025-05-16 13:22:47', 1, 0, NULL, NULL, '2025-05-16 13:22:47', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923247947018002432, 'PUN0001000014', '(青科)2024级-应用生物技术班主任', '(青科)2024级-应用生物技术班主任', NULL, '15000002006', '$2a$10$PJ4yny/EEjJDuZHg14/nMuepqiUDwkYCbJ0vV1lbXfPiiyI2CLsfm', '$2a$10$PJ4yny/EEjJDuZHg14/nMu', '2025-05-28', '00', NULL, 0, '2025-05-16 13:23:38', 1, 0, NULL, NULL, '2025-05-16 13:23:38', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923248008405835776, 'PUN0001000015', '(青科)2024级-计算机科学与技术班主任', '(青科)2024级-计算机科学与技术班主任', NULL, '15000002007', '$2a$10$rm8v1AOLG9YgpRDwd3.oBOBnBy6WIfMrxwV1oh23Hfz4oyoOWJzJS', '$2a$10$rm8v1AOLG9YgpRDwd3.oBO', '2025-05-28', '00', NULL, 0, '2025-05-16 13:23:52', 1, 0, NULL, NULL, '2025-05-16 13:23:52', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_plate_user` (`id`, `plate_user_no`, `nick_name`, `real_name`, `id_card_no`, `phone`, `password`, `salt`, `birthday`, `gender`, `avatar_url`, `real_name_flag`, `last_login_time`, `active_flag`, `write_off_flag`, `default_tenant_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923346043890581504, 'PUN0001000016', '多租户测试用户', '多租户测试用户', NULL, '15000003001', '$2a$10$XgkcT7H7zuQJsZrdhwysxO5CpwVZL32xQLHp5lglCiNDSR0xxQGje', '$2a$10$XgkcT7H7zuQJsZrdhwysxO', '2025-05-27', '00', NULL, 0, '2025-05-16 19:53:26', 1, 0, 1922608866285805568, NULL, '2025-05-16 19:53:26', 1, '2025-05-18 18:25:03', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_plate_user_wechat_info
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_plate_user_wechat_info`;
CREATE TABLE `pserv_uacs_plate_user_wechat_info` (
  `id` bigint NOT NULL COMMENT '主键',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信公众平台openId',
  `union_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信公众号unionid',
  `session_key` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户session_ke',
  `nick_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  `gender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '性别',
  `language` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言',
  `city` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '城市',
  `province` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '省份',
  `country` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '国家',
  `avatar_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '头像',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-平台用户表';

-- ----------------------------
-- Records of pserv_uacs_plate_user_wechat_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_department
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_department`;
CREATE TABLE `pserv_uacs_tenant_department` (
  `id` bigint NOT NULL COMMENT '主键',
  `pid` bigint DEFAULT NULL COMMENT '父节点id',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户编号',
  `tenant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构名称',
  `leaf_flag` tinyint(1) DEFAULT NULL COMMENT '是否是叶子节点',
  `router` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '组织机构路由',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-租户组织机构表';

-- ----------------------------
-- Records of pserv_uacs_tenant_department
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 0, 1, 'PTN000000', '技术锻造系统租户', 'TDN000000', '核心开发团队', 1, '0,1', NULL, '2025-05-08 21:17:13', 9999, '2025-05-08 13:37:10', NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1922615662333325312, NULL, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000002', '青岛大学本部', 0, '0,1922615662333325312', NULL, '2025-05-14 19:31:12', 1, '2025-05-15 21:30:54', 1, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008070171062272, 1922615662333325312, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000003', '计算机学院', 0, '0,1922615662333325312,1923008070171062272', NULL, '2025-05-15 21:30:26', 1, '2025-05-15 21:56:32', 1, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008186340700160, 1922615662333325312, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000004', '数学学院', 0, '0,1922615662333325312,1923008186340700160', NULL, '2025-05-15 21:30:54', 1, '2025-05-15 21:56:14', 1, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008291751948288, NULL, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000005', '青岛科技大学本部', 0, '0,1923008291751948288', NULL, '2025-05-15 21:31:19', 1, '2025-05-15 21:31:50', 1, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008373691871232, 1923008291751948288, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000006', '计算机学院', 0, '0,1923008291751948288,1923008373691871232', NULL, '2025-05-15 21:31:39', 1, '2025-05-15 22:05:06', 1, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008420458360832, 1923008291751948288, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000007', '生物学院', 0, '0,1923008291751948288,1923008420458360832', NULL, '2025-05-15 21:31:50', 1, '2025-05-15 22:04:35', 1, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008574435454976, 1923008070171062272, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000008', '2025级-计算机科学与技术', 1, '0,1922615662333325312,1923008070171062272,1923008574435454976', NULL, '2025-05-15 21:32:27', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923008658933903360, 1923008373691871232, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000009', '2025级-计算机科学与技术', 1, '0,1923008291751948288,1923008373691871232,1923008658933903360', NULL, '2025-05-15 21:32:47', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923011997453086720, 1923008420458360832, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000010', '2025级-应用生物技术', 1, '0,1923008291751948288,1923008420458360832,1923011997453086720', NULL, '2025-05-15 21:46:03', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923012134149648384, 1923008186340700160, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000011', '2025级-应用数学', 1, '0,1922615662333325312,1923008186340700160,1923012134149648384', NULL, '2025-05-15 21:46:35', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923014562899128320, 1923008186340700160, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000012', '2024级-应用数学', 1, '0,1922615662333325312,1923008186340700160,1923014562899128320', NULL, '2025-05-15 21:56:14', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923014638832807936, 1923008070171062272, 1922608908870574080, 'PTN0001000005', '青岛大学', 'TDN0001000013', '2024级-计算机科学与技术', 1, '0,1922615662333325312,1923008070171062272,1923014638832807936', NULL, '2025-05-15 21:56:32', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923016662882213888, 1923008420458360832, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000015', '2024级-应用生物技术', 1, '0,1923008291751948288,1923008420458360832,1923016662882213888', NULL, '2025-05-15 22:04:35', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department` (`id`, `pid`, `tenant_id`, `tenant_no`, `tenant_name`, `department_no`, `department_name`, `leaf_flag`, `router`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923016793178267648, 1923008373691871232, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 'TDN0001000016', '2024级-计算机科学与技术', 1, '0,1923008291751948288,1923008373691871232,1923016793178267648', NULL, '2025-05-15 22:05:06', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_department_post
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_department_post`;
CREATE TABLE `pserv_uacs_tenant_department_post` (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户no',
  `tenant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `department_id` bigint DEFAULT NULL COMMENT '组织机构id',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构名称',
  `post_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '岗位no',
  `post_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '岗位名称',
  `active_flag` tinyint(1) DEFAULT NULL COMMENT '是否可用',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-租户岗位信息表';

-- ----------------------------
-- Records of pserv_uacs_tenant_department_post
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 1, 'PTN000000', '技术锻造系统租户', 1, 'TDN000000', '核心开发团队', 'DPN000000', '开发岗位', 1, NULL, '2025-05-08 21:18:55', 9999, '2025-05-08 13:38:15', NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251145187385344, 1922608908870574080, 'PTN0001000005', '青岛大学', 1922615662333325312, 'TDN0001000002', '青岛大学本部', 'DPN0001000002', '校长', 1, NULL, '2025-05-16 13:36:20', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251228729532416, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008070171062272, 'TDN0001000003', '计算机学院', 'DPN0001000003', '主任', 1, NULL, '2025-05-16 13:36:40', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251309901897728, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008186340700160, 'TDN0001000004', '数学学院', 'DPN0001000004', '主任', 1, NULL, '2025-05-16 13:36:59', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251369809141760, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008574435454976, 'TDN0001000008', '2025级-计算机科学与技术', 'DPN0001000005', '班主任', 1, NULL, '2025-05-16 13:37:14', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251410200289280, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923012134149648384, 'TDN0001000011', '2025级-应用数学', 'DPN0001000006', '班主任', 1, NULL, '2025-05-16 13:37:23', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251444371283968, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014562899128320, 'TDN0001000012', '2024级-应用数学', 'DPN0001000007', '班主任', 1, NULL, '2025-05-16 13:37:31', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923251474289254400, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014638832807936, 'TDN0001000013', '2024级-计算机科学与技术', 'DPN0001000008', '班主任', 1, NULL, '2025-05-16 13:37:38', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252976533757952, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008291751948288, 'TDN0001000005', '青岛科技大学本部', 'DPN0001000009', '校长', 1, NULL, '2025-05-16 13:43:37', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253013108088832, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008373691871232, 'TDN0001000006', '计算机学院', 'DPN0001000010', '主任', 1, NULL, '2025-05-16 13:43:45', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253099040989184, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008420458360832, 'TDN0001000007', '生物学院', 'DPN0001000011', '主任', 1, NULL, '2025-05-16 13:44:06', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253158713352192, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008658933903360, 'TDN0001000009', '2025级-计算机科学与技术', 'DPN0001000012', '班主任', 1, NULL, '2025-05-16 13:44:20', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253196826992640, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923011997453086720, 'TDN0001000010', '2025级-应用生物技术', 'DPN0001000013', '班主任', 1, NULL, '2025-05-16 13:44:29', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253231903956992, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923016662882213888, 'TDN0001000015', '2024级-应用生物技术', 'DPN0001000014', '班主任', 1, NULL, '2025-05-16 13:44:37', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_department_post` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_no`, `post_name`, `active_flag`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253268163715072, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923016793178267648, 'TDN0001000016', '2024级-计算机科学与技术', 'DPN0001000015', '班主任', 1, NULL, '2025-05-16 13:44:46', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_plate_user_post_ref
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_plate_user_post_ref`;
CREATE TABLE `pserv_uacs_tenant_plate_user_post_ref` (
  `id` bigint NOT NULL COMMENT '主键',
  `plate_user_id` bigint DEFAULT NULL COMMENT '平台用户id',
  `plate_user_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '平台用户编号',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户编号',
  `tenant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `department_id` bigint DEFAULT NULL COMMENT '组织机构id',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构名称',
  `post_id` bigint DEFAULT NULL COMMENT '岗位id',
  `post_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '岗位编号',
  `post_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '岗位名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_plate_user_id` (`plate_user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-平台用户与租户岗位关系表';

-- ----------------------------
-- Records of pserv_uacs_tenant_plate_user_post_ref
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 1, 'PUN000000001', 1, 'PTN000000', '技术锻造系统租户', 1, 'TDN000000', '核心开发团队', 1, 'DPN000000', '开发岗位', '2025-03-30 10:15:14', 0, '2025-05-08 13:38:23', NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270183011606528, 1923013599480082432, 'PUN0001000002', 1922608908870574080, 'PTN0001000005', '青岛大学', 1922615662333325312, 'TDN0001000002', '青岛大学本部', 1923251145187385344, 'DPN0001000002', '校长', '2025-05-16 14:51:59', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270244248444928, 1923014066587136000, 'PUN0001000003', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008070171062272, 'TDN0001000003', '计算机学院', 1923251228729532416, 'DPN0001000003', '主任', '2025-05-16 14:52:14', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270280764055552, 1923014309210845184, 'PUN0001000004', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008186340700160, 'TDN0001000004', '数学学院', 1923251309901897728, 'DPN0001000004', '主任', '2025-05-16 14:52:22', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270379216953344, 1923245370658381824, 'PUN0001000005', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008574435454976, 'TDN0001000008', '2025级-计算机科学与技术', 1923251369809141760, 'DPN0001000005', '班主任', '2025-05-16 14:52:46', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270427619221504, 1923245449976864768, 'PUN0001000006', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923012134149648384, 'TDN0001000011', '2025级-应用数学', 1923251410200289280, 'DPN0001000006', '班主任', '2025-05-16 14:52:57', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270460502564864, 1923245539164545024, 'PUN0001000007', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014562899128320, 'TDN0001000012', '2024级-应用数学', 1923251444371283968, 'DPN0001000007', '班主任', '2025-05-16 14:53:05', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270503947165696, 1923245596249022464, 'PUN0001000008', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014638832807936, 'TDN0001000013', '2024级-计算机科学与技术', 1923251474289254400, 'DPN0001000008', '班主任', '2025-05-16 14:53:15', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270542379573248, 1923247317339725824, 'PUN0001000009', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008291751948288, 'TDN0001000005', '青岛科技大学本部', 1923252976533757952, 'DPN0001000009', '校长', '2025-05-16 14:53:25', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270570250723328, 1923247403025162240, 'PUN0001000010', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008373691871232, 'TDN0001000006', '计算机学院', 1923253013108088832, 'DPN0001000010', '主任', '2025-05-16 14:53:31', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270598511943680, 1923247514119692288, 'PUN0001000011', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008420458360832, 'TDN0001000007', '生物学院', 1923253099040989184, 'DPN0001000011', '主任', '2025-05-16 14:53:38', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270635916746752, 1923247636501094400, 'PUN0001000012', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008658933903360, 'TDN0001000009', '2025级-计算机科学与技术', 1923253158713352192, 'DPN0001000012', '班主任', '2025-05-16 14:53:47', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270660570865664, 1923247734840745984, 'PUN0001000013', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923011997453086720, 'TDN0001000010', '2025级-应用生物技术', 1923253196826992640, 'DPN0001000013', '班主任', '2025-05-16 14:53:53', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270694909632512, 1923247947018002432, 'PUN0001000014', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923016662882213888, 'TDN0001000015', '2024级-应用生物技术', 1923253231903956992, 'DPN0001000014', '班主任', '2025-05-16 14:54:01', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923270714660610048, 1923248008405835776, 'PUN0001000015', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923016793178267648, 'TDN0001000016', '2024级-计算机科学与技术', 1923253268163715072, 'DPN0001000015', '班主任', '2025-05-16 14:54:06', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923671972672303104, 1923346043890581504, 'PUN0001000016', 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008070171062272, 'TDN0001000003', '计算机学院', 1923251228729532416, 'DPN0001000003', '主任', '2025-05-17 17:28:33', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_plate_user_post_ref` (`id`, `plate_user_id`, `plate_user_no`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923671972705857536, 1923346043890581504, 'PUN0001000016', 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008658933903360, 'TDN0001000009', '2025级-计算机科学与技术', 1923253158713352192, 'DPN0001000012', '班主任', '2025-05-17 17:28:33', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_post_data_rule_ref
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_post_data_rule_ref`;
CREATE TABLE `pserv_uacs_tenant_post_data_rule_ref` (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户no',
  `tenant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `department_id` bigint DEFAULT NULL COMMENT '组织机构id',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构名称',
  `post_id` bigint DEFAULT NULL COMMENT '租户岗位id',
  `post_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户岗位编号',
  `post_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户岗位名称',
  `data_rule_id` bigint DEFAULT NULL COMMENT '数据规则id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-岗位数据权限规则';

-- ----------------------------
-- Records of pserv_uacs_tenant_post_data_rule_ref
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268019526688768, 1922608908870574080, 'PTN0001000005', '青岛大学', 1922615662333325312, 'TDN0001000002', '青岛大学本部', 1923251145187385344, 'DPN0001000002', '校长', 2, '2025-05-16 14:43:23', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268019564437504, 1922608908870574080, 'PTN0001000005', '青岛大学', 1922615662333325312, 'TDN0001000002', '青岛大学本部', 1923251145187385344, 'DPN0001000002', '校长', 3, '2025-05-16 14:43:23', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268019610574848, 1922608908870574080, 'PTN0001000005', '青岛大学', 1922615662333325312, 'TDN0001000002', '青岛大学本部', 1923251145187385344, 'DPN0001000002', '校长', 10, '2025-05-16 14:43:23', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268054893060096, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008070171062272, 'TDN0001000003', '计算机学院', 1923251228729532416, 'DPN0001000003', '主任', 2, '2025-05-16 14:43:32', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268054935003136, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008070171062272, 'TDN0001000003', '计算机学院', 1923251228729532416, 'DPN0001000003', '主任', 3, '2025-05-16 14:43:32', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268054976946176, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008070171062272, 'TDN0001000003', '计算机学院', 1923251228729532416, 'DPN0001000003', '主任', 10, '2025-05-16 14:43:32', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268079803031552, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008186340700160, 'TDN0001000004', '数学学院', 1923251309901897728, 'DPN0001000004', '主任', 2, '2025-05-16 14:43:37', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268079840780288, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008186340700160, 'TDN0001000004', '数学学院', 1923251309901897728, 'DPN0001000004', '主任', 3, '2025-05-16 14:43:37', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923268079874334720, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008186340700160, 'TDN0001000004', '数学学院', 1923251309901897728, 'DPN0001000004', '主任', 10, '2025-05-16 14:43:37', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385623733882880, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008291751948288, 'TDN0001000005', '青岛科技大学本部', 1923252976533757952, 'DPN0001000009', '校长', 2, '2025-05-16 22:30:42', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385623771631616, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008291751948288, 'TDN0001000005', '青岛科技大学本部', 1923252976533757952, 'DPN0001000009', '校长', 3, '2025-05-16 22:30:42', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385623813574656, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008291751948288, 'TDN0001000005', '青岛科技大学本部', 1923252976533757952, 'DPN0001000009', '校长', 10, '2025-05-16 22:30:42', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385706839822336, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008373691871232, 'TDN0001000006', '计算机学院', 1923253013108088832, 'DPN0001000010', '主任', 2, '2025-05-16 22:31:02', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385706885959680, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008373691871232, 'TDN0001000006', '计算机学院', 1923253013108088832, 'DPN0001000010', '主任', 3, '2025-05-16 22:31:02', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385706919514112, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008373691871232, 'TDN0001000006', '计算机学院', 1923253013108088832, 'DPN0001000010', '主任', 10, '2025-05-16 22:31:02', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385744466923520, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008420458360832, 'TDN0001000007', '生物学院', 1923253099040989184, 'DPN0001000011', '主任', 2, '2025-05-16 22:31:11', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385744504672256, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008420458360832, 'TDN0001000007', '生物学院', 1923253099040989184, 'DPN0001000011', '主任', 3, '2025-05-16 22:31:11', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385744542420992, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008420458360832, 'TDN0001000007', '生物学院', 1923253099040989184, 'DPN0001000011', '主任', 10, '2025-05-16 22:31:11', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385890277707776, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014638832807936, 'TDN0001000013', '2024级-计算机科学与技术', 1923251474289254400, 'DPN0001000008', '班主任', 10, '2025-05-16 22:31:46', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385890315456512, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014638832807936, 'TDN0001000013', '2024级-计算机科学与技术', 1923251474289254400, 'DPN0001000008', '班主任', 3, '2025-05-16 22:31:46', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385890357399552, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014638832807936, 'TDN0001000013', '2024级-计算机科学与技术', 1923251474289254400, 'DPN0001000008', '班主任', 2, '2025-05-16 22:31:46', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385915858767872, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014562899128320, 'TDN0001000012', '2024级-应用数学', 1923251444371283968, 'DPN0001000007', '班主任', 10, '2025-05-16 22:31:52', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385915900710912, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014562899128320, 'TDN0001000012', '2024级-应用数学', 1923251444371283968, 'DPN0001000007', '班主任', 2, '2025-05-16 22:31:52', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385915934265344, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923014562899128320, 'TDN0001000012', '2024级-应用数学', 1923251444371283968, 'DPN0001000007', '班主任', 3, '2025-05-16 22:31:52', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385940877791232, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923012134149648384, 'TDN0001000011', '2025级-应用数学', 1923251410200289280, 'DPN0001000006', '班主任', 10, '2025-05-16 22:31:58', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385940911345664, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923012134149648384, 'TDN0001000011', '2025级-应用数学', 1923251410200289280, 'DPN0001000006', '班主任', 2, '2025-05-16 22:31:58', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385940953288704, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923012134149648384, 'TDN0001000011', '2025级-应用数学', 1923251410200289280, 'DPN0001000006', '班主任', 3, '2025-05-16 22:31:58', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385971173249024, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008574435454976, 'TDN0001000008', '2025级-计算机科学与技术', 1923251369809141760, 'DPN0001000005', '班主任', 10, '2025-05-16 22:32:05', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385971210997760, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008574435454976, 'TDN0001000008', '2025级-计算机科学与技术', 1923251369809141760, 'DPN0001000005', '班主任', 3, '2025-05-16 22:32:05', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923385971244552192, 1922608908870574080, 'PTN0001000005', '青岛大学', 1923008574435454976, 'TDN0001000008', '2025级-计算机科学与技术', 1923251369809141760, 'DPN0001000005', '班主任', 2, '2025-05-16 22:32:05', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1924034068295516160, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923011997453086720, 'TDN0001000010', '2025级-应用生物技术', 1923253196826992640, 'DPN0001000013', '班主任', 10, '2025-05-18 17:27:23', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1924034138533330944, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923016662882213888, 'TDN0001000015', '2024级-应用生物技术', 1923253231903956992, 'DPN0001000014', '班主任', 10, '2025-05-18 17:27:40', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1924034156145213440, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923016793178267648, 'TDN0001000016', '2024级-计算机科学与技术', 1923253268163715072, 'DPN0001000015', '班主任', 10, '2025-05-18 17:27:44', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_data_rule_ref` (`id`, `tenant_id`, `tenant_no`, `tenant_name`, `department_id`, `department_no`, `department_name`, `post_id`, `post_no`, `post_name`, `data_rule_id`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1924034182166675456, 1922608866285805568, 'PTN0001000004', '青岛科技大学', 1923008658933903360, 'TDN0001000009', '2025级-计算机科学与技术', 1923253158713352192, 'DPN0001000012', '班主任', 10, '2025-05-18 17:27:51', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_post_role_ref
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_post_role_ref`;
CREATE TABLE `pserv_uacs_tenant_post_role_ref` (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户no',
  `department_id` bigint DEFAULT NULL COMMENT '组织机构id',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织机构名称',
  `post_id` bigint DEFAULT NULL COMMENT '租户岗位id',
  `role_id` bigint DEFAULT NULL COMMENT '应用角色id',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-岗位与系统角色关系表';

-- ----------------------------
-- Records of pserv_uacs_tenant_post_role_ref
-- ----------------------------
BEGIN;
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1, 1, 'PTN000000', 1, 'TDN000000', '核心开发团队', 1, 1, NULL, '2025-03-30 10:17:29', 0, '2025-05-08 13:37:39', NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252733775831040, 1922608908870574080, 'PTN0001000005', 1922615662333325312, 'TDN0001000002', '青岛大学本部', 1923251145187385344, 1923248313776332800, '', '2025-05-16 13:42:39', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252754143371264, 1922608908870574080, 'PTN0001000005', 1923008070171062272, 'TDN0001000003', '计算机学院', 1923251228729532416, 1923249655123140608, '', '2025-05-16 13:42:44', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252788503109632, 1922608908870574080, 'PTN0001000005', 1923008186340700160, 'TDN0001000004', '数学学院', 1923251309901897728, 1923249655123140608, '', '2025-05-16 13:42:52', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252811919908864, 1922608908870574080, 'PTN0001000005', 1923008574435454976, 'TDN0001000008', '2025级-计算机科学与技术', 1923251369809141760, 1923249698148311040, '', '2025-05-16 13:42:57', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252831616360448, 1922608908870574080, 'PTN0001000005', 1923012134149648384, 'TDN0001000011', '2025级-应用数学', 1923251410200289280, 1923249698148311040, '', '2025-05-16 13:43:02', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252846388699136, 1922608908870574080, 'PTN0001000005', 1923014562899128320, 'TDN0001000012', '2024级-应用数学', 1923251444371283968, 1923249698148311040, '', '2025-05-16 13:43:06', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923252862016675840, 1922608908870574080, 'PTN0001000005', 1923014638832807936, 'TDN0001000013', '2024级-计算机科学与技术', 1923251474289254400, 1923249698148311040, '', '2025-05-16 13:43:09', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253312396845056, 1922608866285805568, 'PTN0001000004', 1923008291751948288, 'TDN0001000005', '青岛科技大学本部', 1923252976533757952, 1923248313776332800, '', '2025-05-16 13:44:57', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253344508436480, 1922608866285805568, 'PTN0001000004', 1923008373691871232, 'TDN0001000006', '计算机学院', 1923253013108088832, 1923249655123140608, '', '2025-05-16 13:45:04', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253366255902720, 1922608866285805568, 'PTN0001000004', 1923008420458360832, 'TDN0001000007', '生物学院', 1923253099040989184, 1923249655123140608, '', '2025-05-16 13:45:09', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253393434992640, 1922608866285805568, 'PTN0001000004', 1923008658933903360, 'TDN0001000009', '2025级-计算机科学与技术', 1923253158713352192, 1923249698148311040, '', '2025-05-16 13:45:16', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253409595645952, 1922608866285805568, 'PTN0001000004', 1923011997453086720, 'TDN0001000010', '2025级-应用生物技术', 1923253196826992640, 1923249698148311040, '', '2025-05-16 13:45:20', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253423604621312, 1922608866285805568, 'PTN0001000004', 1923016662882213888, 'TDN0001000015', '2024级-应用生物技术', 1923253231903956992, 1923249698148311040, '', '2025-05-16 13:45:23', 1, NULL, NULL, NULL);
INSERT INTO `pserv_uacs_tenant_post_role_ref` (`id`, `tenant_id`, `tenant_no`, `department_id`, `department_no`, `department_name`, `post_id`, `role_id`, `notes`, `create_time`, `create_by`, `update_time`, `update_by`, `ext_info`) VALUES (1923253438972551168, 1922608866285805568, 'PTN0001000004', 1923016793178267648, 'TDN0001000016', '2024级-计算机科学与技术', 1923253268163715072, 1923249698148311040, '', '2025-05-16 13:45:27', 1, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_user_invite
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_user_invite`;
CREATE TABLE `pserv_uacs_tenant_user_invite` (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户编号',
  `tanant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `invite_user_id` bigint DEFAULT NULL COMMENT '邀请用户id',
  `invite_user_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邀请用户编号',
  `invite_user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邀请用户名称',
  `department_id` bigint DEFAULT NULL COMMENT '邀请加入组织id',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邀请加入组织编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邀请加入组织名称',
  `post_id` bigint DEFAULT NULL COMMENT '担任岗位id',
  `post_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '担任岗位编号',
  `post_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '担任岗位名称',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-租户用户邀请函';

-- ----------------------------
-- Records of pserv_uacs_tenant_user_invite
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for pserv_uacs_tenant_user_post_apply
-- ----------------------------
DROP TABLE IF EXISTS `pserv_uacs_tenant_user_post_apply`;
CREATE TABLE `pserv_uacs_tenant_user_post_apply` (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `tenant_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户编号',
  `tanant_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户名称',
  `apply_user_id` bigint DEFAULT NULL COMMENT '申请用户id',
  `apply_user_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '申请用户编号',
  `apply_user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '申请用户名称',
  `department_id` bigint DEFAULT NULL COMMENT '申请加入组织id',
  `department_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '申请加入组织编号',
  `department_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '申请加入组织名称',
  `post_id` bigint DEFAULT NULL COMMENT '申请岗位id',
  `post_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '申请岗位编号',
  `post_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '申请岗位名称',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拓展信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开发平台-UACS-用户岗位申请';

-- ----------------------------
-- Records of pserv_uacs_tenant_user_post_apply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- View structure for pserv_uacs_view_tenant_department_user
-- ----------------------------
DROP VIEW IF EXISTS `pserv_uacs_view_tenant_department_user`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `pserv_uacs_view_tenant_department_user` AS select `pserv_uacs_tenant_plate_user_post_ref`.`tenant_id` AS `tenant_id`,`pserv_uacs_tenant_plate_user_post_ref`.`tenant_no` AS `tenant_no`,`pserv_uacs_tenant_plate_user_post_ref`.`tenant_name` AS `tenant_name`,`pserv_uacs_tenant_plate_user_post_ref`.`department_id` AS `department_id`,`pserv_uacs_tenant_plate_user_post_ref`.`department_no` AS `department_no`,`pserv_uacs_tenant_plate_user_post_ref`.`department_name` AS `department_name`,`pserv_uacs_plate_user`.`id` AS `id`,`pserv_uacs_plate_user`.`plate_user_no` AS `plate_user_no`,`pserv_uacs_plate_user`.`nick_name` AS `nick_name`,`pserv_uacs_plate_user`.`real_name` AS `real_name`,`pserv_uacs_plate_user`.`id_card_no` AS `id_card_no`,`pserv_uacs_plate_user`.`phone` AS `phone`,`pserv_uacs_plate_user`.`password` AS `password`,`pserv_uacs_plate_user`.`salt` AS `salt`,`pserv_uacs_plate_user`.`birthday` AS `birthday`,`pserv_uacs_plate_user`.`gender` AS `gender`,`pserv_uacs_plate_user`.`avatar_url` AS `avatar_url`,`pserv_uacs_plate_user`.`real_name_flag` AS `real_name_flag`,`pserv_uacs_plate_user`.`last_login_time` AS `last_login_time`,`pserv_uacs_plate_user`.`active_flag` AS `active_flag`,`pserv_uacs_plate_user`.`write_off_flag` AS `write_off_flag`,`pserv_uacs_plate_user`.`notes` AS `notes`,`pserv_uacs_plate_user`.`create_time` AS `create_time`,`pserv_uacs_plate_user`.`create_by` AS `create_by`,`pserv_uacs_plate_user`.`update_time` AS `update_time`,`pserv_uacs_plate_user`.`update_by` AS `update_by`,`pserv_uacs_plate_user`.`ext_info` AS `ext_info` from (`pserv_uacs_plate_user` left join `pserv_uacs_tenant_plate_user_post_ref` on((`pserv_uacs_plate_user`.`id` = `pserv_uacs_tenant_plate_user_post_ref`.`plate_user_id`)));

SET FOREIGN_KEY_CHECKS = 1;
